package com.eshop.modules.activity.service.mapper;

import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;
import com.eshop.modules.activity.domain.UserExtract;
import com.eshop.common.mapper.CoreMapper;

@Repository
public interface UserExtractMapper extends CoreMapper<UserExtract>
{
    @Select({ "select IFNULL(sum(extract_price),0) from user_extract where status=1 and uid=#{uid}" })
    double sumPrice(@Param("uid") final Long uid);
}
